IF EXISTS ( SELECT 'X' FROM sys.views WHERE name = 'sysdtslog90' AND schema_id = 1 )
BEGIN
     DROP VIEW [dbo].[sysdtslog90]
END
GO

CREATE VIEW [dbo].[sysdtslog90]
AS
/*
 *
 * sysdtslog90
 *
 * Purpose:      
 *
 * Inputs:       
 *
 * Assumes:      
 *
 * Effects:      
 *
 * Returns:      
 *
 * Calling
 * Application:  
 *
 * Note(s):      
 *
 * Author(s):    NOVA Concepts Ltd.
 *
 * Change Log:   Initial Release, 06/07/2009, 1.00.0000
 *
 */
SELECT [id]          = EventLogId,
       [event]       = MiscVC1,
       [computer]    = MiscVC2,
       [operator]    = MiscVC3,
       [source]      = CONVERT( varchar(1024), TraceText ),
       [sourceid]    = MiscGUID1,
       [executionid] = MiscGUID4,
       [starttime]   = MiscDt1,
       [endtime]     = MiscDt2,
       [datacode]    = MiscInt1,
       [databytes]   = TraceImage,
       [message]     = CONVERT( varchar(2048), LogText )
FROM   dbo.EventLog
WHERE  LogByApp          = 'Integration Services'
AND    LogByAppSubSystem = 'sp_dts_addlogentry'
GO
